--------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\wb614536\Downloads\replication\replication\code\../outputs/20_AppendixA_log.txt
  log type:  text
 opened on:  25 Jun 2026, 13:04:07
r; t=0.00 13:04:07

. 
. include "_OutcomeLabels.do"

. /*==============================================================================
>   _OutcomeLabels.do  (helper, not run on its own)
> 
>   Defines polished, publication-ready labels for every outcome that appears
>   in figures and tables. Labels use the macro pattern `lbl_<outcome>`.
>   Visualization do files `include` this file and reference `lbl_<outcome>`
>   to print a pretty label rather than the raw Stata variable name.
> 
>   Categorical/binary indicators are suffixed with "[=1]" so the reader sees
>   what a unit change means; counts and continuous variables get explicit
>   units; standardized indices are flagged "(SD)".
> 
>   Sandra Rozo
> ==============================================================================*/
. 
. * ---- Economic well-being -----------------------------------------------------
. local lbl_jeea_index_wellbeing  "Well-being index (SD)"
r; t=0.00 13:04:07

. local lbl_labour_income         "Log monthly labor income"
r; t=0.00 13:04:07

. local lbl_gasto_capita          "Log per-capita HH consumption"
r; t=0.00 13:04:07

. local lbl_income_maxhh          "Log HH-max labor income"
r; t=0.00 13:04:07

. local lbl_employed              "Employed [=1]"
r; t=0.00 13:04:07

. 
. * ---- Labor ------------------------------------------------------------------
. local lbl_jeea_index_labor      "Labor index (SD)"
r; t=0.00 13:04:07

. local lbl_formal                "Formal employment [=1]"
r; t=0.00 13:04:07

. local lbl_hora_semana           "Log weekly hours (salaried)"
r; t=0.00 13:04:07

. 
. * ---- Services and rights ----------------------------------------------------
. local lbl_jeea_index_services   "Services index (SD)"
r; t=0.00 13:04:07

. local lbl_sisben                "SISBEN registration [=1]"
r; t=0.00 13:04:07

. local lbl_subs                  "Subsidized health [=1]"
r; t=0.00 13:04:07

. local lbl_bank                  "Savings account [=1]"
r; t=0.00 13:04:07

. local lbl_has_bank_account      "Bank account (incl. savings) [=1]"
r; t=0.00 13:04:07

. local lbl_govtr                 "Govt. transfers [=1]"
r; t=0.00 13:04:07

. 
. * ---- Health -----------------------------------------------------------------
. local lbl_health_pca            "Health PCA index (SD)"
r; t=0.00 13:04:07

. local lbl_anx_depr              "Severe anxiety/depression [=1]"
r; t=0.00 13:04:07

. local lbl_any_anx_depr          "Any anxiety/depression [=1]"
r; t=0.00 13:04:07

. local lbl_vas_score             "Self-rated health (0-100)"
r; t=0.00 13:04:07

. local lbl_phys_problem          "Physical health problem [=1]"
r; t=0.00 13:04:07

. local lbl_chronic_illness       "Chronic illness [=1]"
r; t=0.00 13:04:07

. local lbl_mh_index              "Mental-health composite (SD)"
r; t=0.00 13:04:07

. local lbl_life_satisfaction     "Life satisfaction (0-10)"
r; t=0.00 13:04:07

. local lbl_hi5_inv               "EQ-5D anx/depr (5-low to 1-high)"
r; t=0.00 13:04:07

. 
. * ---- Food security ----------------------------------------------------------
. local lbl_index_food            "Food security index (SD)"
r; t=0.00 13:04:07

. local lbl_skip_meals            "Skipped meals last month [=1]"
r; t=0.00 13:04:07

. local lbl_went_without_food     "Went without food [=1]"
r; t=0.00 13:04:07

. local lbl_protein_days          "Days w/ protein (last week)"
r; t=0.00 13:04:07

. local lbl_food_insecure_seek    "Sought food assistance [=1]"
r; t=0.00 13:04:07

. 
. * ---- Housing ----------------------------------------------------------------
. local lbl_index_housing         "Housing quality index (SD)"
r; t=0.00 13:04:07

. local lbl_adequate_housing      "Adequate housing [=1]"
r; t=0.00 13:04:07

. local lbl_has_electricity       "Has electricity [=1]"
r; t=0.00 13:04:07

. local lbl_has_water             "Has running water [=1]"
r; t=0.00 13:04:07

. local lbl_has_sewage            "Has sewage [=1]"
r; t=0.00 13:04:07

. 
. * ---- Integration ------------------------------------------------------------
. local lbl_index_integration     "Integration index (SD)"
r; t=0.00 13:04:07

. local lbl_belonging             "Sense of belonging (1-4)"
r; t=0.00 13:04:07

. local lbl_feel_integrated       "Feels integrated (1-4)"
r; t=0.00 13:04:07

. local lbl_trust_col             "Trust in Colombians (out-group, 1-5)"
r; t=0.00 13:04:07

. local lbl_trust_ven             "Trust in Venezuelans (in-group, 1-5)"
r; t=0.00 13:04:07

. local lbl_general_trust         "General trust in people (1-5)"
r; t=0.00 13:04:07

. local lbl_venezuelans_help_me   "Venezuelans help me (1-5)"
r; t=0.00 13:04:07

. local lbl_trust_index           "Prosocial behaviors composite (SD)"
r; t=0.00 13:04:07

. local lbl_col_friends           "Number Colombian friends"
r; t=0.00 13:04:07

. local lbl_community_org         "Belongs to community org [=1]"
r; t=0.00 13:04:07

. local lbl_connection_colombia   "Strong connection to Colombia [=1]"
r; t=0.00 13:04:07

. local lbl_colombians_help_me    "Colombians help me (1-5)"
r; t=0.00 13:04:07

. local lbl_count_on_col          "Can count on Colombians (1-5)"
r; t=0.00 13:04:07

. 
. * ---- Discrimination ---------------------------------------------------------
. local lbl_index_discrim         "Discrimination index (SD)"
r; t=0.00 13:04:07

. local lbl_discrim_ever          "Ever discriminated against [=1]"
r; t=0.00 13:04:07

. local lbl_discrim_freq          "Discrimination frequency (1-5)"
r; t=0.00 13:04:07

. local lbl_filed_complaint       "Filed discrimination complaint [=1]"
r; t=0.00 13:04:07

. 
. * ---- Migration intentions ---------------------------------------------------
. local lbl_intend_stay           "Intends to stay in Colombia [=1]"
r; t=0.00 13:04:07

. local lbl_plan_stay_5yr         "Plans to stay 5+ years [=1]"
r; t=0.00 13:04:07

. local lbl_considered_return_ven "Considered returning to Venezuela [=1]"
r; t=0.00 13:04:07

. 
. * ---- COVID -----------------------------------------------------------------
. local lbl_index_covid           "COVID resilience index (SD)"
r; t=0.00 13:04:07

. local lbl_covid_income_down     "Income fell during COVID [=1]"
r; t=0.00 13:04:07

. local lbl_covid_eviction        "Faced eviction during COVID [=1]"
r; t=0.00 13:04:07

. local lbl_covid_received_aid    "Received COVID aid [=1]"
r; t=0.00 13:04:07

. 
. * ---- Education -------------------------------------------------------------
. local lbl_currently_studying    "Currently studying [=1]"
r; t=0.00 13:04:07

. local lbl_currently_enrolled    "Currently enrolled in school [=1]"
r; t=0.00 13:04:07

. local lbl_degree_validated      "Foreign degree validated [=1]"
r; t=0.00 13:04:07

. 
. * ---- Children --------------------------------------------------------------
. local lbl_child_skip_meals      "Child skipped meals [=1]"
r; t=0.00 13:04:07

. local lbl_child_vaccinated      "Child vaccinated [=1]"
r; t=0.00 13:04:07

. local lbl_child_worked          "Child worked [=1]"
r; t=0.00 13:04:07

. 
. * ---- Remittances -----------------------------------------------------------
. local lbl_index_remit           "Remittances index (SD)"
r; t=0.00 13:04:07

. local lbl_remit_now             "Sends remittances now [=1]"
r; t=0.00 13:04:07

. local lbl_remit_to_parents      "Remits to parents [=1]"
r; t=0.00 13:04:07

. 
. * ---- Financial access and digital ------------------------------------------
. local lbl_index_fin_access      "Financial access index (SD)"
r; t=0.00 13:04:07

. local lbl_index_digital         "Digital access index (SD)"
r; t=0.00 13:04:07

. local lbl_has_savings_account   "Has savings account [=1]"
r; t=0.00 13:04:07

. local lbl_has_mobile_money      "Has mobile money [=1]"
r; t=0.00 13:04:07

. local lbl_has_smartphone        "Has smartphone [=1]"
r; t=0.00 13:04:07

. local lbl_has_internet          "Has internet [=1]"
r; t=0.00 13:04:07

. local lbl_apps_whatsapp         "Uses WhatsApp [=1]"
r; t=0.00 13:04:07

. 
. * ============================================================================
. *  PREDETERMINED COVARIATES (used for balance tests and as RD controls)
. * ============================================================================
. 
. * ---- Demographics ----------------------------------------------------------
. local lbl_female                "Female [=1]"
r; t=0.00 13:04:07

. local lbl_age_panel             "Age (years)"
r; t=0.00 13:04:07

. local lbl_yrseduc               "Years of education"
r; t=0.00 13:04:07

. local lbl_time_col              "Years in Colombia"
r; t=0.00 13:04:07

. local lbl_child_venez           "Has child born in Venezuela [=1]"
r; t=0.00 13:04:07

. 
. * ---- Pre-migration economic conditions (in Venezuela) ----------------------
. local lbl_jobopp                "Had a job offer in Colombia [=1]"
r; t=0.00 13:04:07

. local lbl_labven                "Worked in Venezuela [=1]"
r; t=0.00 13:04:07

. local lbl_typeworkven1          "Worked in agric./manual (VZ) [=1]"
r; t=0.00 13:04:07

. local lbl_typeworkven2          "Worked in services (VZ) [=1]"
r; t=0.00 13:04:07

. local lbl_typeworkven3          "Worked in skilled occ. (VZ) [=1]"
r; t=0.00 13:04:07

. local lbl_written_cont          "Had written contract (VZ) [=1]"
r; t=0.00 13:04:07

. local lbl_average               "Avg. days worked / week (VZ)"
r; t=0.00 13:04:07

. local lbl_smartven              "Owned smartphone in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_owner                 "Homeowner in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_electven              "Had electricity in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_waterven              "Had running water in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_sewageven             "Had sewage in VZ [=1]"
r; t=0.00 13:04:07

. 
. * ---- Family / migration network -------------------------------------------
. local lbl_hhven_parents         "Parents born in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_hhven_spouse          "Spouse born in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_hhven_other           "Other HH members born in VZ [=1]"
r; t=0.00 13:04:07

. local lbl_healthmig             "Healthy at migration [=1]"
r; t=0.00 13:04:07

. local lbl_frdfam                "Network in Colombia [=1]"
r; t=0.00 13:04:07

. r; t=0.01 13:04:07

. 
. di "=================================================================="
==================================================================
r; t=0.00 13:04:07

. di "  20_AppendixA_Comprehensive.do  —  $S_DATE  $S_TIME"
  20_AppendixA_Comprehensive.do  —  25 Jun 2026  13:04:07
r; t=0.00 13:04:07

. di "=================================================================="
==================================================================
r; t=0.00 13:04:07

. 
. /*==============================================================================
>   PART 1: APPLY JEEA-STYLE SAMPLE RESTRICTIONS
> ==============================================================================*/
. 
. use "$clean/PEP_Analysis_Sample.dta", clear
(PEP analysis sample (JEEA-style + extended outcome indices))
r; t=0.13 13:04:08

. 
. local jeea_controls hhven_spouse hhven_other jobopp labven ///
>                     typeworkven1 typeworkven2 typeworkven3 ///
>                     written_cont average yrseduc healthmig frdfam ///
>                     smartven owner electven waterven sewageven female ///
>                     age_panel child_venez time_col
r; t=0.00 13:04:08

. 
. gen sample_roster = .
(13,580 missing values generated)
r; t=0.00 13:04:08

. qui reg trt_hh `jeea_controls'
r; t=2.36 13:04:10

. replace sample_roster = e(sample)
(13,580 real changes made)
r; t=0.00 13:04:10

. replace sample_roster = 0 if gasto_capita == . & trt_hh != .
(119 real changes made)
r; t=0.00 13:04:10

. replace sample_roster = 0 if employed == . & trt_hh != .
(88 real changes made)
r; t=0.00 13:04:10

. replace sample_roster = 0 if hora_semana == . & trt_hh != . & asalariado_num == 1
(64 real changes made)
r; t=0.00 13:04:10

. replace sample_roster = 0 if anx_depr == .
(2 real changes made)
r; t=0.00 13:04:10

. replace sample_roster = 0 if health_pca == .
(8 real changes made)
r; t=0.00 13:04:10

. bysort family_id: egen sample_reg = max(sample_roster)
r; t=0.01 13:04:10

. keep if (orden == 1 | orden == 2) & sample_reg == 1
(6,451 observations deleted)
r; t=0.02 13:04:10

. 
. /*==============================================================================
>   PART 2: GROUP STRUCTURE
> ==============================================================================*/
. 
. * Each group: name, list of variables, description
. * Order matches main-paper Tables 3-9, then appendix-only groups, then covariates.
. * Outcome groups follow the body tables (Tables 1-7) exactly.
. local g_econ      jeea_index_wellbeing labour_income gasto_capita health_pca
r; t=0.00 13:04:10

. local g_services  jeea_index_services sisben subs has_bank_account govtr
r; t=0.00 13:04:10

. local g_labor     jeea_index_labor labour_income employed formal hora_semana
r; t=0.00 13:04:10

. local g_integ     index_integration belonging feel_integrated col_friends community_org connection_colombia
r; t=0.00 13:04:10

. local g_trust     trust_index general_trust trust_col trust_ven colombians_help_me venezuelans_help_me
r; t=0.00 13:04:10

. local g_food      index_food skip_meals went_without_food protein_days
r; t=0.00 13:04:10

. local g_health    mh_index health_pca life_satisfaction hi5_inv anx_depr any_anx_depr vas_score phys_problem chron
> ic_illness
r; t=0.00 13:04:10

. local g_housing   index_housing adequate_housing has_electricity has_water has_sewage
r; t=0.00 13:04:10

. local g_discrim   index_discrim discrim_ever discrim_freq filed_complaint
r; t=0.00 13:04:10

. local g_migrat    intend_stay plan_stay_5yr considered_return_ven
r; t=0.00 13:04:10

. local g_educ      currently_studying currently_enrolled degree_validated
r; t=0.00 13:04:10

. local g_child     child_skip_meals child_vaccinated child_worked
r; t=0.00 13:04:10

. local g_remit     index_remit remit_now remit_to_parents
r; t=0.00 13:04:10

. local g_fin       index_fin_access has_savings_account has_mobile_money
r; t=0.00 13:04:10

. local g_digital   index_digital has_smartphone has_internet apps_whatsapp
r; t=0.00 13:04:10

. local g_demog     female age_panel yrseduc time_col child_venez
r; t=0.00 13:04:10

. local g_pre       jobopp labven typeworkven1 typeworkven2 typeworkven3 written_cont average smartven owner electve
> n waterven sewageven
r; t=0.00 13:04:10

. local g_network   hhven_spouse hhven_other healthmig frdfam
r; t=0.00 13:04:10

. 
. local group_codes econ services labor integ trust food housing health discrim migrat educ child remit fin digital 
> demog pre network
r; t=0.00 13:04:10

. 
. * Titles map to main-paper table numbers where applicable
. local title_econ      "A. Economic well-being (body Table 1)"
r; t=0.00 13:04:10

. local title_services  "B. Services and rights (body Table 2)"
r; t=0.00 13:04:10

. local title_labor     "C. Labor market (body Table 3)"
r; t=0.00 13:04:10

. local title_integ     "D. Integration (body Table 4)"
r; t=0.00 13:04:10

. local title_trust     "E. Prosocial behaviors (body Table 5)"
r; t=0.00 13:04:10

. local title_food      "F. Food security (body Table 6)"
r; t=0.00 13:04:10

. local title_housing   "G. Housing quality (body Table 7)"
r; t=0.00 13:04:10

. local title_health    "H. Mental and physical health (appendix only)"
r; t=0.00 13:04:10

. local title_discrim   "I. Discrimination (appendix only)"
r; t=0.00 13:04:10

. local title_migrat    "J. Migration intentions (appendix only)"
r; t=0.00 13:04:10

. local title_educ      "K. Adult education (appendix only)"
r; t=0.00 13:04:10

. local title_child     "L. Child outcomes (appendix only)"
r; t=0.00 13:04:10

. local title_remit     "M. Remittances (appendix only)"
r; t=0.00 13:04:10

. local title_fin       "N. Financial access (appendix only)"
r; t=0.00 13:04:10

. local title_digital   "O. Digital inclusion (appendix only)"
r; t=0.00 13:04:10

. local title_demog     "P. Demographics (covariate)"
r; t=0.00 13:04:10

. local title_pre       "Q. Pre-migration economic conditions in Venezuela (covariate)"
r; t=0.00 13:04:10

. local title_network   "R. Family / migration network in Colombia (covariate)"
r; t=0.00 13:04:10

. 
. /*==============================================================================
>   PART 3: WRITE ONE VARIABLE-DEFINITIONS TABLE PER OUTCOME GROUP
> ==============================================================================*/
. 
. foreach g of local group_codes {
  2.     local glist  "`g_`g''"
  3.     local gtitle "`title_`g''"
  4. 
.     file open T using "$atab/tabA_def_`g'.tex", write replace text
  5.     file write T "\begin{table}[!htbp]" _n
  6.     file write T "\centering" _n
  7.     file write T "\caption{Variable definitions: `gtitle'}" _n
  8.     file write T "\label{tab:def_`g'}" _n
  9.     file write T "\begin{threeparttable}" _n
 10.     file write T "\renewcommand{\arraystretch}{1.05}" _n
 11.     file write T "\begin{tabular}{p{0.55\textwidth} p{0.30\textwidth}}" _n
 12.     file write T "\toprule" _n
 13.     file write T "Variable & Type \\" _n
 14.     file write T "\midrule" _n
 15. 
.     foreach v of local glist {
 16.         local lbl "`lbl_`v''"
 17.         if "`lbl'" == "" {
 18.             capture local lbl : variable label `v'
 19.             if "`lbl'" == "" local lbl "`v'"
 20.         }
 21.         local vtype = ""
 22.         capture confirm variable `v'
 23.         if _rc == 0 {
 24.             qui sum `v'
 25.             local mn = r(min)
 26.             local mx = r(max)
 27.             if !missing(`mn', `mx') {
 28.                 if `mn' >= 0 & `mx' <= 1 & inlist(round(`mn'), 0, 1) & inlist(round(`mx'), 0, 1) {
 29.                     local vtype "Binary 0/1"
 30.                 }
 31.                 else if abs(`mn') > 0.99 & abs(`mn') < 5 & abs(`mx') < 5 & strpos("`v'", "index") > 0 {
 32.                     local vtype "Index (SD)"
 33.                 }
 34.                 else if strpos("`v'", "log") > 0 | inlist("`v'", "labour_income", "gasto_capita", "income_maxhh
> ") {
 35.                     local vtype "Continuous (log)"
 36.                 }
 37.                 else if inlist("`v'", "jeea_index_wellbeing", "jeea_index_labor", "jeea_index_services", "healt
> h_pca") {
 38.                     local vtype "Index (SD)"
 39.                 }
 40.                 else {
 41.                     local vtype "Continuous"
 42.                 }
 43.             }
 44.             else {
 45.                 local vtype "(no obs.)"
 46.             }
 47.         }
 48.         file write T "`lbl' & `vtype' \\" _n
 49.     }
 50. 
.     file write T "\bottomrule" _n
 51.     file write T "\end{tabular}" _n
 52.     file write T "\begin{tablenotes}\footnotesize" _n
 53.     file write T "\item \textit{Notes}: Variable types: \textquotedblleft Binary 0/1\textquotedblright\ are 0/1
>  indicators; \textquotedblleft Index (SD)\textquotedblright\ are first-principal-component or simple-average indic
> es, standardized to mean 0 and SD 1 in the analysis sample; \textquotedblleft Continuous (log)\textquotedblright\ 
> are natural logarithms of an underlying positive quantity; \textquotedblleft Continuous\textquotedblright\ are non
> -standardized continuous variables in their natural units." _n
 54.     file write T "\end{tablenotes}" _n
 55.     file write T "\end{threeparttable}" _n
 56.     file write T "\end{table}" _n
 57.     file close T
 58. 
.     di "  tabA_def_`g'.tex saved"
 59. }
(file ../outputs/appendix/tables/tabA_def_econ.tex not found)
  tabA_def_econ.tex saved
(file ../outputs/appendix/tables/tabA_def_services.tex not found)
  tabA_def_services.tex saved
(file ../outputs/appendix/tables/tabA_def_labor.tex not found)
  tabA_def_labor.tex saved
(file ../outputs/appendix/tables/tabA_def_integ.tex not found)
  tabA_def_integ.tex saved
(file ../outputs/appendix/tables/tabA_def_trust.tex not found)
  tabA_def_trust.tex saved
(file ../outputs/appendix/tables/tabA_def_food.tex not found)
  tabA_def_food.tex saved
(file ../outputs/appendix/tables/tabA_def_housing.tex not found)
  tabA_def_housing.tex saved
(file ../outputs/appendix/tables/tabA_def_health.tex not found)
  tabA_def_health.tex saved
(file ../outputs/appendix/tables/tabA_def_discrim.tex not found)
  tabA_def_discrim.tex saved
(file ../outputs/appendix/tables/tabA_def_migrat.tex not found)
  tabA_def_migrat.tex saved
(file ../outputs/appendix/tables/tabA_def_educ.tex not found)
  tabA_def_educ.tex saved
(file ../outputs/appendix/tables/tabA_def_child.tex not found)
  tabA_def_child.tex saved
(file ../outputs/appendix/tables/tabA_def_remit.tex not found)
  tabA_def_remit.tex saved
(file ../outputs/appendix/tables/tabA_def_fin.tex not found)
  tabA_def_fin.tex saved
(file ../outputs/appendix/tables/tabA_def_digital.tex not found)
  tabA_def_digital.tex saved
(file ../outputs/appendix/tables/tabA_def_demog.tex not found)
  tabA_def_demog.tex saved
(file ../outputs/appendix/tables/tabA_def_pre.tex not found)
  tabA_def_pre.tex saved
(file ../outputs/appendix/tables/tabA_def_network.tex not found)
  tabA_def_network.tex saved
r; t=0.16 13:04:10

. 
. /*==============================================================================
>   PART 4: WRITE DESCRIPTIVE-STATISTICS TABLE
> ==============================================================================*/
. 
. * Variable -> Level mapping (HH = household-level, Ind. = individual-level).
. * Variables not listed below default to Ind.
. local hh_vars  gasto_capita income_maxhh bank has_bank_account govtr ///
>                has_savings_account has_mobile_money ///
>                index_housing adequate_housing has_electricity has_water has_sewage ///
>                index_remit remit_now remit_to_parents ///
>                index_fin_access index_digital has_smartphone has_internet apps_whatsapp ///
>                child_skip_meals child_vaccinated child_worked ///
>                index_food skip_meals went_without_food protein_days food_insecure_seek ///
>                electven waterven sewageven owner smartven
r; t=0.00 13:04:10

. 
. * Variable -> Construction description.  Short phrase per variable.
. * Indices and composites describe their components; raw items describe scale/units.
. local desc_jeea_index_wellbeing  "Equal-weighted mean of standardized log labor income, log per-capita consumption
> , and employed indicator"
r; t=0.00 13:04:10

. local desc_labour_income         "Log of monthly labor income (COP) for working individuals"
r; t=0.00 13:04:10

. local desc_gasto_capita          "Log of annual per-capita household consumption (millions of COP)"
r; t=0.00 13:04:10

. local desc_income_maxhh          "Log of household-maximum monthly labor income"
r; t=0.00 13:04:10

. local desc_employed              "1 if individual is currently employed"
r; t=0.00 13:04:10

. local desc_jeea_index_services   "Equal-weighted mean of standardized SISBEN, subsidized health, bank, and governm
> ent transfers"
r; t=0.00 13:04:10

. local desc_sisben                "1 if registered in SISBEN social registry"
r; t=0.00 13:04:10

. local desc_subs                  "1 if enrolled in subsidized health insurance"
r; t=0.00 13:04:10

. local desc_bank                  "1 if has any banking product (incl.\ savings)"
r; t=0.00 13:04:10

. local desc_has_bank_account      "1 if has a savings or transactional bank account"
r; t=0.00 13:04:10

. local desc_govtr                 "1 if household received any government transfer"
r; t=0.00 13:04:10

. local desc_jeea_index_labor      "Equal-weighted mean of standardized formal-employment indicator and log weekly h
> ours"
r; t=0.00 13:04:10

. local desc_formal                "1 if individual contributes to social security (formal job)"
r; t=0.00 13:04:10

. local desc_hora_semana           "Log of weekly hours worked, conditional on being salaried"
r; t=0.00 13:04:10

. local desc_index_integration     "Equal-weighted mean of standardized belonging, feels integrated, count of Colomb
> ian friends, community-org membership, and connection-to-Colombia indicators"
r; t=0.00 13:04:10

. local desc_belonging             "Sense of belonging in Colombia (1=low, 4=high)"
r; t=0.00 13:04:10

. local desc_feel_integrated       "Self-reported feeling of integration in Colombia (1=low, 4=high)"
r; t=0.00 13:04:10

. local desc_col_friends           "Count of close Colombian friends"
r; t=0.00 13:04:10

. local desc_community_org         "1 if member of a community organization"
r; t=0.00 13:04:10

. local desc_connection_colombia   "1 if reports a strong connection to Colombia"
r; t=0.00 13:04:10

. local desc_trust_index           "Equal-weighted mean of standardized general trust, trust in Colombians, and trus
> t in Venezuelans"
r; t=0.00 13:04:10

. local desc_general_trust         "General trust in people (1=low, 5=high)"
r; t=0.00 13:04:10

. local desc_trust_col             "Trust in Colombians, out-group (1--5)"
r; t=0.00 13:04:10

. local desc_trust_ven             "Trust in Venezuelans, in-group (1--5)"
r; t=0.00 13:04:10

. local desc_colombians_help_me    "Perception that Colombians want to help me (1--5)"
r; t=0.00 13:04:10

. local desc_venezuelans_help_me   "Perception that Venezuelans want to help me (1--5)"
r; t=0.00 13:04:10

. local desc_index_food            "Equal-weighted mean of standardized skipped meals, went without food, days with 
> protein, and food-assistance-seeking indicators (signs aligned to higher = more food security)"
r; t=0.00 13:04:10

. local desc_skip_meals            "1 if any HH member skipped meals last month"
r; t=0.00 13:04:10

. local desc_went_without_food     "1 if any HH member went a full day without eating last month"
r; t=0.00 13:04:10

. local desc_protein_days          "Days last week with protein consumption (0--7)"
r; t=0.00 13:04:10

. local desc_food_insecure_seek    "1 if HH sought food assistance last month"
r; t=0.00 13:04:10

. local desc_index_housing         "Equal-weighted mean of standardized adequate housing, electricity, water, and se
> wage indicators"
r; t=0.00 13:04:10

. local desc_adequate_housing      "1 if dwelling meets minimum adequacy standards"
r; t=0.00 13:04:10

. local desc_has_electricity       "1 if dwelling has electricity service"
r; t=0.00 13:04:10

. local desc_has_water             "1 if dwelling has running water"
r; t=0.00 13:04:10

. local desc_has_sewage            "1 if dwelling has sewage connection"
r; t=0.00 13:04:10

. local desc_mh_index              "Equal-weighted mean of standardized life satisfaction, EQ-5D anxiety/depression 
> (inverted), any anxiety/depression (inverted), and visual-analog self-rated health"
r; t=0.00 13:04:10

. local desc_health_pca            "First principal component of self-rated and physical-health items (PCA index)"
r; t=0.00 13:04:10

. local desc_life_satisfaction     "Self-reported life satisfaction (0--10)"
r; t=0.00 13:04:10

. local desc_hi5_inv               "EQ-5D anxiety/depression item, reverse coded so higher = less anxiety (1=low, 5=
> high)"
r; t=0.00 13:04:10

. local desc_anx_depr              "1 if reports severe anxiety or depression"
r; t=0.00 13:04:10

. local desc_any_anx_depr          "1 if reports any anxiety or depression symptoms"
r; t=0.00 13:04:10

. local desc_vas_score             "Visual-analog self-rated health score (0--100)"
r; t=0.00 13:04:10

. local desc_phys_problem          "1 if reports a current physical health problem"
r; t=0.00 13:04:10

. local desc_chronic_illness       "1 if reports a chronic illness"
r; t=0.00 13:04:10

. local desc_index_discrim         "Equal-weighted mean of standardized discrimination indicators (signs aligned)"
r; t=0.00 13:04:10

. local desc_discrim_ever          "1 if ever felt discriminated against in Colombia"
r; t=0.00 13:04:10

. local desc_discrim_freq          "Frequency of discrimination experienced (1=never, 5=very often)"
r; t=0.00 13:04:10

. local desc_filed_complaint       "1 if ever filed a discrimination complaint"
r; t=0.00 13:04:10

. local desc_intend_stay           "1 if intends to stay in Colombia"
r; t=0.00 13:04:10

. local desc_plan_stay_5yr         "1 if plans to stay in Colombia for five or more years"
r; t=0.00 13:04:10

. local desc_considered_return_ven "1 if has considered returning to Venezuela"
r; t=0.00 13:04:10

. local desc_currently_studying    "1 if currently studying"
r; t=0.00 13:04:10

. local desc_currently_enrolled    "1 if currently enrolled in a Colombian institution"
r; t=0.00 13:04:10

. local desc_degree_validated      "1 if foreign degree validated in Colombia"
r; t=0.00 13:04:10

. local desc_child_skip_meals      "1 if any child in HH skipped meals last month"
r; t=0.00 13:04:10

. local desc_child_vaccinated      "1 if all HH children with current vaccinations"
r; t=0.00 13:04:10

. local desc_child_worked          "1 if any HH child worked for pay"
r; t=0.00 13:04:10

. local desc_index_remit           "Equal-weighted mean of standardized remittance indicators"
r; t=0.00 13:04:10

. local desc_remit_now             "1 if currently sends remittances to Venezuela"
r; t=0.00 13:04:10

. local desc_remit_to_parents      "1 if remits to parents in Venezuela"
r; t=0.00 13:04:10

. local desc_index_fin_access      "Equal-weighted mean of standardized savings account and mobile money indicators"
r; t=0.00 13:04:10

. local desc_has_savings_account   "1 if HH has a savings account"
r; t=0.00 13:04:10

. local desc_has_mobile_money      "1 if HH uses mobile money"
r; t=0.00 13:04:10

. local desc_index_digital         "Equal-weighted mean of standardized smartphone, internet, and WhatsApp indicator
> s"
r; t=0.00 13:04:10

. local desc_has_smartphone        "1 if owns a smartphone"
r; t=0.00 13:04:10

. local desc_has_internet          "1 if has internet at home"
r; t=0.00 13:04:10

. local desc_apps_whatsapp         "1 if uses WhatsApp"
r; t=0.00 13:04:10

. local desc_female                "1 if female"
r; t=0.00 13:04:10

. local desc_age_panel             "Age in years at survey"
r; t=0.00 13:04:10

. local desc_yrseduc               "Years of education at arrival in Colombia"
r; t=0.00 13:04:10

. local desc_time_col              "Months in Colombia at the time of the survey"
r; t=0.00 13:04:10

. local desc_child_venez           "Number of children born in Venezuela"
r; t=0.00 13:04:10

. local desc_jobopp                "1 if had a job offer in Colombia at arrival"
r; t=0.00 13:04:10

. local desc_labven                "1 if worked in Venezuela before migrating"
r; t=0.00 13:04:10

. local desc_typeworkven1          "1 if worked in agriculture or manual labor in Venezuela"
r; t=0.00 13:04:10

. local desc_typeworkven2          "1 if worked in services in Venezuela"
r; t=0.00 13:04:10

. local desc_typeworkven3          "1 if worked in skilled occupations in Venezuela"
r; t=0.00 13:04:10

. local desc_written_cont          "1 if had a written contract in Venezuela"
r; t=0.00 13:04:10

. local desc_average               "Average days worked per week in Venezuela"
r; t=0.00 13:04:10

. local desc_smartven              "1 if owned a smartphone in Venezuela"
r; t=0.00 13:04:10

. local desc_owner                 "1 if homeowner in Venezuela"
r; t=0.00 13:04:10

. local desc_electven              "1 if had electricity in Venezuela dwelling"
r; t=0.00 13:04:10

. local desc_waterven              "1 if had running water in Venezuela dwelling"
r; t=0.00 13:04:10

. local desc_sewageven             "1 if had sewage in Venezuela dwelling"
r; t=0.00 13:04:10

. local desc_hhven_spouse          "1 if spouse born in Venezuela"
r; t=0.00 13:04:10

. local desc_hhven_other           "1 if any other HH member born in Venezuela"
r; t=0.00 13:04:10

. local desc_healthmig             "1 if reported good health at the time of migration"
r; t=0.00 13:04:10

. local desc_frdfam                "1 if had family or friends in Colombia at arrival"
r; t=0.00 13:04:10

. 
. * Per-group descriptive-statistics tables (one per outcome group, to avoid
. * page-overflow when a single combined table grows too long).
. foreach g of local group_codes {
  2.     local glist  "`g_`g''"
  3.     local gtitle "`title_`g''"
  4. 
.     file open T using "$atab/tabA_desc_`g'.tex", write replace text
  5.     file write T "\begin{table}[!htbp]" _n
  6.     file write T "\centering" _n
  7.     file write T "\caption{Descriptive statistics by wave: `gtitle'}" _n
  8.     file write T "\label{tab:desc_`g'}" _n
  9.     file write T "\begin{threeparttable}" _n
 10.     file write T "\renewcommand{\arraystretch}{1.05}" _n
 11.     file write T "\footnotesize" _n
 12.     file write T "\begin{tabular}{p{3.4cm}cp{4.6cm}*{6}{r}}" _n
 13.     file write T "\toprule" _n
 14.     file write T " &  &  & \multicolumn{3}{c}{Wave 1 (2020)} & \multicolumn{3}{c}{Wave 2 (2021)} \\" _n
 15.     file write T "\cmidrule(lr){4-6} \cmidrule(lr){7-9}" _n
 16.     file write T "Variable & Level & Construction & Mean & SD & N & Mean & SD & N \\" _n
 17.     file write T "\midrule" _n
 18. 
.     foreach v of local glist {
 19.         local lbl "`lbl_`v''"
 20.         if "`lbl'" == "" {
 21.             capture local lbl : variable label `v'
 22.             if "`lbl'" == "" local lbl "`v'"
 23.         }
 24.         * Determine level
.         local lvl "Ind."
 25.         foreach hv of local hh_vars {
 26.             if "`hv'" == "`v'" local lvl "HH"
 27.         }
 28.         local descv "`desc_`v''"
 29.         if "`descv'" == "" local descv "---"
 30. 
.         capture confirm variable `v'
 31.         if _rc != 0 {
 32.             file write T "`lbl' & `lvl' & `descv' & --- & --- & --- & --- & --- & --- \\" _n
 33.         }
 34.         else {
 35.             qui sum `v' if wave_num == 1
 36.             if r(N) == 0 {
 37.                 local mn1 "---"
 38.                 local sd1 "---"
 39.                 local n1  "0"
 40.             }
 41.             else {
 42.                 local mn1 = string(r(mean), "%9.3f")
 43.                 local sd1 = string(r(sd),   "%9.3f")
 44.                 local n1  = string(r(N),    "%9.0fc")
 45.             }
 46.             qui sum `v' if wave_num == 2
 47.             if r(N) == 0 {
 48.                 local mn2 "---"
 49.                 local sd2 "---"
 50.                 local n2  "0"
 51.             }
 52.             else {
 53.                 local mn2 = string(r(mean), "%9.3f")
 54.                 local sd2 = string(r(sd),   "%9.3f")
 55.                 local n2  = string(r(N),    "%9.0fc")
 56.             }
 57.             file write T "`lbl' & `lvl' & `descv' & `mn1' & `sd1' & `n1' & `mn2' & `sd2' & `n2' \\" _n
 58.         }
 59.     }
 60. 
.     file write T "\bottomrule" _n
 61.     file write T "\end{tabular}" _n
 62.     file write T "\begin{tablenotes}\footnotesize" _n
 63.     file write T "\item \textit{Notes}: Within-wave descriptive statistics on the JEEA-style analysis sample (h
> eads and spouses, \textit{orden} $\in \{1,2\}$, sample\_reg == 1). The Level column indicates the unit at which ea
> ch variable is recorded in the survey: \textit{Ind.} for individual-level items (asked of each roster member) and 
> \textit{HH} for household-level items (asked of the head and assigned to all members for the analysis). The Constr
> uction column gives a brief description of how the variable is constructed; full coding is in the project replicat
> ion files. Variables labeled \textquotedblleft (SD)\textquotedblright\ are standardized to mean 0 and SD 1 within 
> each wave (see Section~A introduction for the index-construction convention); \textquotedblleft [=1]\textquotedblr
> ight\ are 0/1 indicators." _n
 64.     file write T "\end{tablenotes}" _n
 65.     file write T "\end{threeparttable}" _n
 66.     file write T "\end{table}" _n
 67.     file close T
 68. 
.     di "  tabA_desc_`g'.tex saved"
 69. }
  tabA_desc_econ.tex saved
  tabA_desc_services.tex saved
  tabA_desc_labor.tex saved
  tabA_desc_integ.tex saved
  tabA_desc_trust.tex saved
  tabA_desc_food.tex saved
  tabA_desc_housing.tex saved
(file ../outputs/appendix/tables/tabA_desc_health.tex not found)
  tabA_desc_health.tex saved
  tabA_desc_discrim.tex saved
  tabA_desc_migrat.tex saved
  tabA_desc_educ.tex saved
(file ../outputs/appendix/tables/tabA_desc_child.tex not found)
  tabA_desc_child.tex saved
  tabA_desc_remit.tex saved
  tabA_desc_fin.tex saved
(file ../outputs/appendix/tables/tabA_desc_digital.tex not found)
  tabA_desc_digital.tex saved
  tabA_desc_demog.tex saved
  tabA_desc_pre.tex saved
  tabA_desc_network.tex saved
r; t=0.57 13:04:11

. 
. di ""

r; t=0.00 13:04:11

. di "=================================================================="
==================================================================
r; t=0.00 13:04:11

. di "  20_AppendixA_Comprehensive.do done."
  20_AppendixA_Comprehensive.do done.
r; t=0.00 13:04:11

. di "=================================================================="
==================================================================
r; t=0.00 13:04:11

. 
. log close
      name:  <unnamed>
       log:  C:\Users\wb614536\Downloads\replication\replication\code\../outputs/20_AppendixA_log.txt
  log type:  text
 closed on:  25 Jun 2026, 13:04:11
--------------------------------------------------------------------------------------------------------------------
